Re: Primary Key - Mailing list pgsql-jdbc

From
Subject Re: Primary Key
Date
Msg-id 20020329120914.FGLD1369.mta3@[194.153.172.197]
Whole thread Raw
In response to Primary Key  (raghu nidagal <raghuramn@hotvoice.com>)
Responses getColumns()
List pgsql-jdbc
No, the OID, as every system field, isn't retrieved automatcally in a ResulSet, for example with a query such as:
"SELECT* FROM Addr;". You must specify the system fields that you want. For example "SELECT oid,* FROM Addr;". 

I have a question. Is it possible, after a table creation, to declare a field as a PRIMARY KEY? In particular I want to
declareexplicity the system field oid as a PRIMARY KEY. 

Many thanks!

Riccardo


__________________________________________


Fai i tuoi acquisti su www.kwshopping.it


pgsql-jdbc by date:

Previous
From: tony
Date:
Subject: Re: Accents for TEXT
Next
From: "Bullock, Dempsey"
Date:
Subject: Building PGSQL 7.2 Failing